home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 4,101 to 4,200
/
aol-file-protocol-4400-4101-to-4200.zip
/
AOLDLs
/
Business Management
/
VLO_ V98 Virtual Law Office
/
FREEVL~1.exe
/
_SETUP.1
/
CurrBills.qbe
< prev
next >
Wrap
Text File
|
1998-04-18
|
3KB
|
54 lines
Query
ANSWER: :PRIV:CurrBills.db.DB
SORT: :LOData:Parties.DB->"PL2Names", :LOData:Cases.DB->"CaseKey",
:LOData:Cases.DB->"CaseType", :LOData:Cases.DB->"DateOpened", :LOData:Cases.DB->"DateClosed",
:LOData:Cases.DB->"AlphaCaseNumber", :LOData:Cases.DB->"CaseDescription", :LOData:Cases.DB->"CPrintLabel",
:LOData:Cases.DB->"CCheckConflicts", :LOData:Cases.DB->"CAttyAssigned", :LOData:Cases.DB->"CIncidentDate",
:LOData:Cases.DB->"CStatuteRunDate", :LOData:Cases.DB->"CBilltype", :LOData:Cases.DB->"CLastBilled",
:LOData:Cases.DB->"CPreviousBalance", :LOData:Parties.DB->"PL2Cases", :LOData:Parties.DB->"PRole",
:LOData:Names.DB->"NAMEKEY", :LOData:Names.DB->"Last Name", :LOData:Names.DB->"First Name",
:LOData:Names.DB->"Middle Name", :LOData:Names.DB->"Prefix", :LOData:Names.DB->"Suffix",
:LOData:Names.DB->"Description", :LOData:Names.DB->"Address Line 1", :LOData:Names.DB->"Address Line 2",
:LOData:Names.DB->"Address Line 3", :LOData:Names.DB->"City", :LOData:Names.DB->"State", :LOData:Names.DB->"Zip",
:LOData:Names.DB->"NameType", :LOData:Names.DB->"Date Created", :LOData:Names.DB->"Date Inactive",
:LOData:Names.DB->"Salutation"
:LOData:Cases.DB | CaseKey | CaseType | DateOpened | DateClosed | CIcon |
| Check _join1 | Check | Check | Check | Check |
:LOData:Cases.DB | AlphaCaseNumber | CaseDescription | CPrintLabel |
| Check | Check | Check |
:LOData:Cases.DB | CCheckConflicts | COurReference | CAttyAssigned |
| Check | Check | Check |
:LOData:Cases.DB | CIncidentDate | CStatuteRunDate | CCaption | CBilltype |
| Check | Check | Check | Check |
:LOData:Cases.DB | CLastBilled | CPreviousBalance | CNarrative |
| Check | Check | Check |
:LOData:Parties.DB | PL2Cases | PL2Names | PRole |
| Check _join1 | Check _join2 | Check Client |
:LOData:Parties.DB | PTheirReference |
| Check |
:LOData:Names.DB | NAMEKEY | Last Name | First Name | Middle Name |
| Check _join2 | Check | Check | Check |
:LOData:Names.DB | Prefix | Suffix | Description | Address Line 1 |
| Check | Check | Check | Check |
:LOData:Names.DB | Address Line 2 | Address Line 3 | City | State | Zip |
| Check | Check | Check | Check | Check |
:LOData:Names.DB | NameType | Date Created | Date Inactive | Inactive Reason |
| Check | Check | Check | Check |
:LOData:Names.DB | Comments and Notes | Salutation |
| Check | Check |
EndQuery